INDEX UNIQUE SCAN
Short Description
The INDEX UNIQUE SCAN returns at most one rowid from an index.
Detailed Description​
The INDEX UNIQUE SCAN returns at most one rowid from an index. The scan will stop as soon as the first rowid is returned.
The index must have been created as a UNIQUE index and the query predicate must be an equality expression such as WHERE AREA_ID = 51.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.